SHOW FULL COLUMNS FROM `xin_quotation` [ RunTime:0.001750s ]
SHOW FULL COLUMNS FROM `xin_company` [ RunTime:0.001297s ]
SHOW FULL COLUMNS FROM `xin_sort` [ RunTime:0.000779s ]
SELECT `id`,name as title FROM `xin_sort` WHERE `deep` = 1 ORDER BY `orderby` ASC [ RunTime:0.000288s ]
SELECT
p.id,
p.title,
c.id AS com_id,
c.user_id,
c.title AS com_title,
p.price_tax,
p.price_no_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 update_time DESC, 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.238720s ]
SELECT
p.id,
p.title,
c.id AS com_id,
c.user_id,
c.title AS com_title,
p.price_tax,
p.price_no_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 update_time DESC, 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.235163s ]
SELECT
p.id,
p.title,
c.id AS com_id,
c.user_id,
c.title AS com_title,
p.price_tax,
p.price_no_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 update_time DESC, 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.233015s ]
SELECT
p.id,
p.title,
c.id AS com_id,
c.user_id,
c.title AS com_title,
p.price_tax,
p.price_no_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 update_time DESC, 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.231659s ]
SELECT
p.id,
p.title,
c.id AS com_id,
c.user_id,
c.title AS com_title,
p.price_tax,
p.price_no_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 update_time DESC, 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.231460s ]
SELECT
p.id,
p.title,
c.id AS com_id,
c.user_id,
c.title AS com_title,
p.price_tax,
p.price_no_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 update_time DESC, 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.232829s ]
SELECT
p.id,
p.title,
c.id AS com_id,
c.user_id,
c.title AS com_title,
p.price_tax,
p.price_no_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 update_time DESC, 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.233495s ]
SELECT
p.id,
p.title,
c.id AS com_id,
c.user_id,
c.title AS com_title,
p.price_tax,
p.price_no_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 update_time DESC, 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.233560s ]
SELECT
p.id,
p.title,
c.id AS com_id,
c.user_id,
c.title AS com_title,
p.price_tax,
p.price_no_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 update_time DESC, 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.218145s ]
SELECT
p.id,
p.title,
c.id AS com_id,
c.user_id,
c.title AS com_title,
p.price_tax,
p.price_no_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 update_time DESC, 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.238406s ]
SELECT
p.id,
p.title,
c.id AS com_id,
c.user_id,
c.title AS com_title,
p.price_tax,
p.price_no_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 update_time DESC, 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.340710s ]
SELECT c.id, c.title, MAX(p.create_time) AS latest_create_date, MAX(p.update_time) AS latest_update_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_update_date DESC, latest_create_date DESC
LIMIT 24 [ RunTime:0.006614s ]
SHOW FULL COLUMNS FROM `xin_expert` [ RunTime:0.001285s ]
SELECT * FROM `xin_expert` WHERE `audit` = 1 ORDER BY `update_time` DESC,`id` DESC LIMIT 15 [ RunTime:0.033751s ]
SHOW FULL COLUMNS FROM `xin_file` [ RunTime:0.001250s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2125 LIMIT 1 [ RunTime:0.000294s ]
SHOW FULL COLUMNS FROM `xin_project` [ RunTime:0.000970s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '21' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001552s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2203 ORDER BY `file_id` ASC [ RunTime:0.000152s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2212 LIMIT 1 [ RunTime:0.000131s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '30' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001464s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2115 LIMIT 1 [ RunTime:0.000138s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '14' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001402s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2117 LIMIT 1 [ RunTime:0.000116s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '15' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001395s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2127 LIMIT 1 [ RunTime:0.000118s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '23' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001408s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2129 LIMIT 1 [ RunTime:0.000126s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '25' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001392s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2130 LIMIT 1 [ RunTime:0.000111s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '26' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001409s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2118 LIMIT 1 [ RunTime:0.000111s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '16' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001401s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2132 LIMIT 1 [ RunTime:0.000120s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '28' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001393s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2131 LIMIT 1 [ RunTime:0.000116s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '27' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001547s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2128 LIMIT 1 [ RunTime:0.000183s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '24' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001430s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2126 LIMIT 1 [ RunTime:0.000127s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '22' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001403s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '44296' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001400s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '44295' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001400s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '44294' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001405s ]
SHOW FULL COLUMNS FROM `xin_adver` [ RunTime:0.000987s ]
SELECT * FROM `xin_adver` WHERE `status` = 1 AND `position_id` = 1 LIMIT 12 [ RunTime:0.000247s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2090 LIMIT 1 [ RunTime:0.000181s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2085 LIMIT 1 [ RunTime:0.000123s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2073 LIMIT 1 [ RunTime:0.000242s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2076 LIMIT 1 [ RunTime:0.000140s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2077 LIMIT 1 [ RunTime:0.000111s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2079 LIMIT 1 [ RunTime:0.000223s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2080 LIMIT 1 [ RunTime:0.000159s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2084 LIMIT 1 [ RunTime:0.000121s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2086 LIMIT 1 [ RunTime:0.000140s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2087 LIMIT 1 [ RunTime:0.000194s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2088 LIMIT 1 [ RunTime:0.000136s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2089 LIMIT 1 [ RunTime:0.000109s ]
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.000411s ]
SHOW FULL COLUMNS FROM `xin_enquiry` [ RunTime:0.000907s ]
SELECT `quotation` FROM `xin_enquiry` ORDER BY `id` DESC LIMIT 100 [ RunTime:0.000168s ]
