SHOW FULL COLUMNS FROM `xin_link` [ RunTime:0.012956s ]
SELECT * FROM `xin_link` ORDER BY `id` ASC LIMIT 10 [ RunTime:0.000257s ]
SHOW FULL COLUMNS FROM `xin_quotation` [ RunTime:0.004454s ]
SHOW FULL COLUMNS FROM `xin_company` [ RunTime:0.004576s ]
SHOW FULL COLUMNS FROM `xin_sort` [ RunTime:0.004308s ]
SELECT `id`,name as title FROM `xin_sort` WHERE `deep` = 1 ORDER BY `orderby` ASC [ RunTime:0.000358s ]
SELECT
p.id,
p.title,
c.id AS com_id,
c.user_id,
c.title AS com_title,
p.price_tax,
p.unit,
c1.name AS sort_title
FROM
xin_quotation p
JOIN xin_sort c1 ON p.sort_id = c1.id
JOIN xin_sort c2 ON c1.pid = c2.id
JOIN xin_sort c3 ON c2.pid = c3.id
JOIN xin_company c ON p.company_id = c.id
JOIN ( SELECT company_id, MAX( id ) AS max_id FROM xin_quotation GROUP BY company_id ORDER BY create_time DESC, id DESC) b ON p.company_id = b.company_id
AND p.id = b.max_id
WHERE
c3.id = '1034'
ORDER BY
p.create_time DESC,
p.id DESC
LIMIT 18 [ RunTime:0.027083s ]
SELECT
p.id,
p.title,
c.id AS com_id,
c.user_id,
c.title AS com_title,
p.price_tax,
p.unit,
c1.name AS sort_title
FROM
xin_quotation p
JOIN xin_sort c1 ON p.sort_id = c1.id
JOIN xin_sort c2 ON c1.pid = c2.id
JOIN xin_sort c3 ON c2.pid = c3.id
JOIN xin_company c ON p.company_id = c.id
JOIN ( SELECT company_id, MAX( id ) AS max_id FROM xin_quotation GROUP BY company_id ORDER BY create_time DESC, id DESC) b ON p.company_id = b.company_id
AND p.id = b.max_id
WHERE
c3.id = '1098'
ORDER BY
p.create_time DESC,
p.id DESC
LIMIT 18 [ RunTime:0.033710s ]
SELECT
p.id,
p.title,
c.id AS com_id,
c.user_id,
c.title AS com_title,
p.price_tax,
p.unit,
c1.name AS sort_title
FROM
xin_quotation p
JOIN xin_sort c1 ON p.sort_id = c1.id
JOIN xin_sort c2 ON c1.pid = c2.id
JOIN xin_sort c3 ON c2.pid = c3.id
JOIN xin_company c ON p.company_id = c.id
JOIN ( SELECT company_id, MAX( id ) AS max_id FROM xin_quotation GROUP BY company_id ORDER BY create_time DESC, id DESC) b ON p.company_id = b.company_id
AND p.id = b.max_id
WHERE
c3.id = '1188'
ORDER BY
p.create_time DESC,
p.id DESC
LIMIT 18 [ RunTime:0.028418s ]
SELECT
p.id,
p.title,
c.id AS com_id,
c.user_id,
c.title AS com_title,
p.price_tax,
p.unit,
c1.name AS sort_title
FROM
xin_quotation p
JOIN xin_sort c1 ON p.sort_id = c1.id
JOIN xin_sort c2 ON c1.pid = c2.id
JOIN xin_sort c3 ON c2.pid = c3.id
JOIN xin_company c ON p.company_id = c.id
JOIN ( SELECT company_id, MAX( id ) AS max_id FROM xin_quotation GROUP BY company_id ORDER BY create_time DESC, id DESC) b ON p.company_id = b.company_id
AND p.id = b.max_id
WHERE
c3.id = '1297'
ORDER BY
p.create_time DESC,
p.id DESC
LIMIT 18 [ RunTime:0.040932s ]
SELECT
p.id,
p.title,
c.id AS com_id,
c.user_id,
c.title AS com_title,
p.price_tax,
p.unit,
c1.name AS sort_title
FROM
xin_quotation p
JOIN xin_sort c1 ON p.sort_id = c1.id
JOIN xin_sort c2 ON c1.pid = c2.id
JOIN xin_sort c3 ON c2.pid = c3.id
JOIN xin_company c ON p.company_id = c.id
JOIN ( SELECT company_id, MAX( id ) AS max_id FROM xin_quotation GROUP BY company_id ORDER BY create_time DESC, id DESC) b ON p.company_id = b.company_id
AND p.id = b.max_id
WHERE
c3.id = '1371'
ORDER BY
p.create_time DESC,
p.id DESC
LIMIT 18 [ RunTime:0.021335s ]
SELECT
p.id,
p.title,
c.id AS com_id,
c.user_id,
c.title AS com_title,
p.price_tax,
p.unit,
c1.name AS sort_title
FROM
xin_quotation p
JOIN xin_sort c1 ON p.sort_id = c1.id
JOIN xin_sort c2 ON c1.pid = c2.id
JOIN xin_sort c3 ON c2.pid = c3.id
JOIN xin_company c ON p.company_id = c.id
JOIN ( SELECT company_id, MAX( id ) AS max_id FROM xin_quotation GROUP BY company_id ORDER BY create_time DESC, id DESC) b ON p.company_id = b.company_id
AND p.id = b.max_id
WHERE
c3.id = '1411'
ORDER BY
p.create_time DESC,
p.id DESC
LIMIT 18 [ RunTime:0.021509s ]
SELECT
p.id,
p.title,
c.id AS com_id,
c.user_id,
c.title AS com_title,
p.price_tax,
p.unit,
c1.name AS sort_title
FROM
xin_quotation p
JOIN xin_sort c1 ON p.sort_id = c1.id
JOIN xin_sort c2 ON c1.pid = c2.id
JOIN xin_sort c3 ON c2.pid = c3.id
JOIN xin_company c ON p.company_id = c.id
JOIN ( SELECT company_id, MAX( id ) AS max_id FROM xin_quotation GROUP BY company_id ORDER BY create_time DESC, id DESC) b ON p.company_id = b.company_id
AND p.id = b.max_id
WHERE
c3.id = '1454'
ORDER BY
p.create_time DESC,
p.id DESC
LIMIT 18 [ RunTime:0.019175s ]
SELECT
p.id,
p.title,
c.id AS com_id,
c.user_id,
c.title AS com_title,
p.price_tax,
p.unit,
c1.name AS sort_title
FROM
xin_quotation p
JOIN xin_sort c1 ON p.sort_id = c1.id
JOIN xin_sort c2 ON c1.pid = c2.id
JOIN xin_sort c3 ON c2.pid = c3.id
JOIN xin_company c ON p.company_id = c.id
JOIN ( SELECT company_id, MAX( id ) AS max_id FROM xin_quotation GROUP BY company_id ORDER BY create_time DESC, id DESC) b ON p.company_id = b.company_id
AND p.id = b.max_id
WHERE
c3.id = '1498'
ORDER BY
p.create_time DESC,
p.id DESC
LIMIT 18 [ RunTime:0.016228s ]
SELECT
p.id,
p.title,
c.id AS com_id,
c.user_id,
c.title AS com_title,
p.price_tax,
p.unit,
c1.name AS sort_title
FROM
xin_quotation p
JOIN xin_sort c1 ON p.sort_id = c1.id
JOIN xin_sort c2 ON c1.pid = c2.id
JOIN xin_sort c3 ON c2.pid = c3.id
JOIN xin_company c ON p.company_id = c.id
JOIN ( SELECT company_id, MAX( id ) AS max_id FROM xin_quotation GROUP BY company_id ORDER BY create_time DESC, id DESC) b ON p.company_id = b.company_id
AND p.id = b.max_id
WHERE
c3.id = '1525'
ORDER BY
p.create_time DESC,
p.id DESC
LIMIT 18 [ RunTime:0.001045s ]
SELECT
p.id,
p.title,
c.id AS com_id,
c.user_id,
c.title AS com_title,
p.price_tax,
p.unit,
c1.name AS sort_title
FROM
xin_quotation p
JOIN xin_sort c1 ON p.sort_id = c1.id
JOIN xin_sort c2 ON c1.pid = c2.id
JOIN xin_sort c3 ON c2.pid = c3.id
JOIN xin_company c ON p.company_id = c.id
JOIN ( SELECT company_id, MAX( id ) AS max_id FROM xin_quotation GROUP BY company_id ORDER BY create_time DESC, id DESC) b ON p.company_id = b.company_id
AND p.id = b.max_id
WHERE
c3.id = '1539'
ORDER BY
p.create_time DESC,
p.id DESC
LIMIT 18 [ RunTime:0.016975s ]
SELECT
p.id,
p.title,
c.id AS com_id,
c.user_id,
c.title AS com_title,
p.price_tax,
p.unit,
c1.name AS sort_title
FROM
xin_quotation p
JOIN xin_sort c1 ON p.sort_id = c1.id
JOIN xin_sort c2 ON c1.pid = c2.id
JOIN xin_sort c3 ON c2.pid = c3.id
JOIN xin_company c ON p.company_id = c.id
JOIN ( SELECT company_id, MAX( id ) AS max_id FROM xin_quotation GROUP BY company_id ORDER BY create_time DESC, id DESC) b ON p.company_id = b.company_id
AND p.id = b.max_id
WHERE
c3.id = '1000'
ORDER BY
p.create_time DESC,
p.id DESC
LIMIT 18 [ RunTime:0.019832s ]
SELECT c.id, c.title, MAX(p.create_time) AS latest_upload_date
FROM xin_company c
JOIN xin_quotation p ON c.id = p.company_id
WHERE c.recommend = 1
GROUP BY c.id, c.title
ORDER BY latest_upload_date DESC
LIMIT 24 [ RunTime:0.002046s ]
SHOW FULL COLUMNS FROM `xin_expert` [ RunTime:0.014039s ]
SELECT * FROM `xin_expert` WHERE `audit` = 1 ORDER BY `id` DESC LIMIT 5 [ RunTime:0.000365s ]
SHOW FULL COLUMNS FROM `xin_file` [ RunTime:0.004545s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2203 ORDER BY `file_id` ASC [ RunTime:0.000283s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2212 LIMIT 1 [ RunTime:0.000227s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2132 LIMIT 1 [ RunTime:0.000176s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2131 LIMIT 1 [ RunTime:0.000115s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2130 LIMIT 1 [ RunTime:0.000117s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2129 LIMIT 1 [ RunTime:0.000177s ]
SHOW FULL COLUMNS FROM `xin_adver` [ RunTime:0.004524s ]
SELECT * FROM `xin_adver` WHERE `status` = 1 AND `position_id` = 1 LIMIT 12 [ RunTime:0.000214s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2090 LIMIT 1 [ RunTime:0.000192s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2085 LIMIT 1 [ RunTime:0.000202s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2073 LIMIT 1 [ RunTime:0.000174s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2076 LIMIT 1 [ RunTime:0.000206s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2077 LIMIT 1 [ RunTime:0.000133s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2079 LIMIT 1 [ RunTime:0.000138s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2080 LIMIT 1 [ RunTime:0.000102s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2084 LIMIT 1 [ RunTime:0.000102s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2086 LIMIT 1 [ RunTime:0.000106s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2087 LIMIT 1 [ RunTime:0.000099s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2088 LIMIT 1 [ RunTime:0.000095s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2089 LIMIT 1 [ RunTime:0.000093s ]
SELECT
e.id,
e.quotation,
e.company,
e.quantity,
e.unit,
e.model,
e.user_id,
ep.price as reply_price,
ep.unit as reply_unit,
ep.create_time as reply_time,
r.name as city_name
FROM
xin_enquiry e
LEFT JOIN (
SELECT
enquiry_id,
price,
unit,
create_time,
ROW_NUMBER() OVER(PARTITION BY enquiry_id ORDER BY create_time DESC) as rn
FROM
xin_enquiry_price) ep ON e.id = ep.enquiry_id AND ep.rn = 1
LEFT JOIN xin_region r on r.id = e.city_id
WHERE e.is_end = 0
ORDER BY e.id DESC LIMIT 10 [ RunTime:0.000371s ]
SHOW FULL COLUMNS FROM `xin_enquiry` [ RunTime:0.004562s ]
SELECT `quotation` FROM `xin_enquiry` ORDER BY `id` DESC LIMIT 100 [ RunTime:0.000210s ]
