Fortek

#undergroundtekno
  BENCHMARKS  
Loading Time: Base Classes  0.0029
Controller Execution Time ( Artists / Index )  0.0217
Total Execution Time  0.0251
  DONNEES GET  
Aucune donnée GET n'existe
  UTILISATION MEMOIRE  
998,880 bytes
  DONNEES POST  
Aucune donnée POST n'existe
  URI STRING  
fr/artists/fortek/6884
  CLASS/METHODE  
artists/index
  BASE DE DONNEES:  undergroundt59_prod (artists:$db)   REQUETES: 4 (0.0039 secondes)  (Cacher)
0.0008   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` = 'tr76bglh40jld8obb4l1htl8m0are53j'
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` = 6884
 LIMIT 1 
0.0014   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` = 6884
GROUP BY 
`p`.`products_id`
ORDER BY `p`.`products_date_availableDESC, `p`.`products_idDESC
 LIMIT 32 
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` = 6884
GROUP BY 
`p`.`products_id`
ORDER BY `p`.`products_date_availableDESC, `p`.`products_idDESC 
  HTTP HEADERS  (Montrer)
  DONNEES SESSION  (Montrer)
  VARIABLES CONFIG  (Montrer)