Clients photo Valerie L. Ellis

(5.0)

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.
Clients photo Rabien Ustoc

(5.0)

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. 

Memory consumed: 104,992 bites
Execution took: 0.0060451030731201 seconds.
Count of queries to db: 4
Array
(
    [0] => SELECT ID AS id, post_title AS title, post_name AS slug, post_date AS date, post_content AS content, (SELECT guid FROM woof_posts WHERE id = woof_postmeta.meta_value) AS thumb_url, (SELECT t.slug 
          FROM woof_term_relationships AS tr
          INNER JOIN woof_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
          INNER JOIN woof_terms AS t ON tt.term_id = t.term_id
          WHERE tt.taxonomy = 'language' AND tr.object_id = id LIMIT 1
        ) AS lang, (SELECT t.term_id
   FROM woof_term_relationships AS tr
   INNER JOIN woof_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
   INNER JOIN woof_terms AS t ON tt.term_id = t.term_id
   WHERE tt.taxonomy = 'brand' AND tr.object_id = id
   LIMIT 1
) AS brand_term_id, (SELECT t.term_id
   FROM woof_term_relationships AS tr
   INNER JOIN woof_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
   INNER JOIN woof_terms AS t ON tt.term_id = t.term_id
   WHERE tt.taxonomy = 'location' AND tr.object_id = id
   LIMIT 1
) AS location_term_id, (SELECT t.term_id
   FROM woof_term_relationships AS tr
   INNER JOIN woof_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
   INNER JOIN woof_terms AS t ON tt.term_id = t.term_id
   WHERE tt.taxonomy = 'body' AND tr.object_id = id
   LIMIT 1
) AS body_term_id FROM woof_posts LEFT JOIN woof_postmeta ON(id = woof_postmeta.post_id AND woof_postmeta.meta_key = '_thumbnail_id') LEFT JOIN woof_term_relationships AS lang_rel ON(id = lang_rel.object_id) LEFT JOIN woof_term_taxonomy AS lang_tax ON(lang_rel.term_taxonomy_id = lang_tax.term_taxonomy_id) LEFT JOIN woof_terms AS lang_term ON(lang_tax.term_id = lang_term.term_id) WHERE post_type = :post_type AND post_status = :post_status AND lang_tax.taxonomy = 'language'  ORDER BY id DESC  LIMIT 99
    [1] => 
        SELECT post_id, meta_key, meta_value
        FROM woof_postmeta
        WHERE post_id IN (819,817)
    
    [2] => SELECT option_name, option_value FROM woof_options WHERE option_name LIKE 'site\_%'
    [3] => SELECT MIN(CAST(pm.meta_value AS UNSIGNED)) AS min_price
FROM woof_posts p
INNER JOIN woof_postmeta pm ON p.ID = pm.post_id
WHERE p.post_type = 'car'
  AND p.post_status = 'publish'
  AND pm.meta_key = 'price'
  AND CAST(pm.meta_value AS UNSIGNED) > 0;

)
Count of included files: 17