Puyu

FSL 17

9.63€
M'alerter dès qu'il est disponible
#undergroundtekno
  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Artists / Index )  0.0215
Total Execution Time  0.0235
  DONNEES GET  
Aucune donnée GET n'existe
  UTILISATION MEMOIRE  
987,848 bytes
  DONNEES POST  
Aucune donnée POST n'existe
  URI STRING  
fr/artists/puyu/923
  CLASS/METHODE  
artists/index
  BASE DE DONNEES:  undergroundt59_prod (artists:$db)   REQUETES: 4 (0.0034 secondes)  (Cacher)
0.0006   SELECT `c`.`cart_id`, `c`.`customers_id`, `c`.`session_id`, `c`.`products_name`, `c`.`products_id`, `c`.`is_free`, `c`.`is_virtual`, `c`.`qty`, `c`.`weight`, `c`.`tax`, `c`.`ht_price`, `c`.`final_price`, `c`.`options_id`, `c`.`options_values_id`, `c`.`is_gift`
FROM `cart` `c`
WHERE `c`.`session_id` = '8k4au9skurl3edi6b3td0db2iqs2n7ja'
AND `c`.`shops_id` = 1
ORDER BY 
`cart_idAS
0.0004   SELECT `a`.`artist_id` as `artists_id`, CONCAT(UCASE(LEFT(a.artist_name1))LCASE(SUBSTRING(a.artist_name2))) as artists_name, `a`.`artist_url` as `artists_url`
FROM `artists` `a`
WHERE `a`.`artist_id` = 923
 LIMIT 1 
0.0013   SELECT `p`.`products_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price
FROM 
`products` `p`
JOIN `products_to_categories` `ptcON `ptc`.`products_id` = `p`.`products_id`
JOIN `manufacturers` `mON `m`.`manufacturers_id` = `p`.`manufacturers_id`
JOIN `categories_shops` `csON `ptc`.`categories_id` = `cs`.`categories_idAND `cs`.`shops_id` = 1
JOIN 
`products_description` `pdON `p`.`products_id` = `pd`.`products_idAND `pd`.`language_id` = 2
JOIN 
`products_shops` `psON `p`.`products_id` = `ps`.`products_idAND `ps`.`shops_id` = 1
LEFT JOIN 
`products_artists` `paON `pa`.`products_id` = `p`.`products_id`
LEFT JOIN `artists` `aON `a`.`artist_id` = `pa`.`artists_id`
LEFT JOIN `specials` `sON `p`.`products_id` = `s`.`products_id`
WHERE `p`.`products_status` = 1
AND `pa`.`artists_id` = 923
GROUP BY 
`p`.`products_id`
ORDER BY `p`.`products_date_availableDESC, `p`.`products_idDESC
 LIMIT 32 
0.0011   SELECT `p`.`products_id`, IF(s.status, `s`.`specials_new_products_price`, NULL) as special_price, IF(s.status, `s`.`specials_new_products_price`, p.products_price) as final_price
FROM 
`products` `p`
JOIN `products_to_categories` `ptcON `ptc`.`products_id` = `p`.`products_id`
JOIN `manufacturers` `mON `m`.`manufacturers_id` = `p`.`manufacturers_id`
JOIN `categories_shops` `csON `ptc`.`categories_id` = `cs`.`categories_idAND `cs`.`shops_id` = 1
JOIN 
`products_description` `pdON `p`.`products_id` = `pd`.`products_idAND `pd`.`language_id` = 2
JOIN 
`products_shops` `psON `p`.`products_id` = `ps`.`products_idAND `ps`.`shops_id` = 1
LEFT JOIN 
`products_artists` `paON `pa`.`products_id` = `p`.`products_id`
LEFT JOIN `artists` `aON `a`.`artist_id` = `pa`.`artists_id`
LEFT JOIN `specials` `sON `p`.`products_id` = `s`.`products_id`
WHERE `p`.`products_status` = 1
AND `pa`.`artists_id` = 923
GROUP BY 
`p`.`products_id`
ORDER BY `p`.`products_date_availableDESC, `p`.`products_idDESC 
  HTTP HEADERS  (Montrer)
  DONNEES SESSION  (Montrer)
  VARIABLES CONFIG  (Montrer)