SHOW FULL COLUMNS FROM `xin_quotation` [ RunTime:0.001318s ]
SHOW FULL COLUMNS FROM `xin_company` [ RunTime:0.000998s ]
SHOW FULL COLUMNS FROM `xin_sort` [ RunTime:0.000732s ]
SELECT `id`,name as title FROM `xin_sort` WHERE `deep` = 1 ORDER BY `orderby` ASC [ RunTime:0.000291s ]
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.237073s ]
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.235646s ]
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.235210s ]
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.236264s ]
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.233765s ]
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.235487s ]
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.231732s ]
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.230562s ]
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.215699s ]
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.234296s ]
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.235607s ]
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.006953s ]
SHOW FULL COLUMNS FROM `xin_expert` [ RunTime:0.001302s ]
SELECT * FROM `xin_expert` WHERE `audit` = 1 ORDER BY `update_time` DESC,`id` DESC LIMIT 15 [ RunTime:0.033646s ]
SHOW FULL COLUMNS FROM `xin_file` [ RunTime:0.001319s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2125 LIMIT 1 [ RunTime:0.000274s ]
SHOW FULL COLUMNS FROM `xin_project` [ RunTime:0.000810s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '21' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001546s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2203 ORDER BY `file_id` ASC [ RunTime:0.000254s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2212 LIMIT 1 [ RunTime:0.000154s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '30' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001444s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2115 LIMIT 1 [ RunTime:0.000122s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '14' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001480s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2117 LIMIT 1 [ RunTime:0.000120s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '15' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001400s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2127 LIMIT 1 [ RunTime:0.000115s ]
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.000110s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '25' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001404s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2130 LIMIT 1 [ RunTime:0.000109s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '26' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001399s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2118 LIMIT 1 [ RunTime:0.000108s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '16' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001395s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2132 LIMIT 1 [ RunTime:0.000109s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '28' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001402s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2131 LIMIT 1 [ RunTime:0.000109s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '27' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001540s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2128 LIMIT 1 [ RunTime:0.000230s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '24' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001455s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2126 LIMIT 1 [ RunTime:0.000136s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '22' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001412s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '44296' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001383s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '44295' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001395s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '44294' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001471s ]
SHOW FULL COLUMNS FROM `xin_adver` [ RunTime:0.000928s ]
SELECT * FROM `xin_adver` WHERE `status` = 1 AND `position_id` = 1 LIMIT 12 [ RunTime:0.000204s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2090 LIMIT 1 [ RunTime:0.000154s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2085 LIMIT 1 [ RunTime:0.000114s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2073 LIMIT 1 [ RunTime:0.000120s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2076 LIMIT 1 [ RunTime:0.000109s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2077 LIMIT 1 [ RunTime:0.000114s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2079 LIMIT 1 [ RunTime:0.000118s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2080 LIMIT 1 [ RunTime:0.000108s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2084 LIMIT 1 [ RunTime:0.000165s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2086 LIMIT 1 [ RunTime:0.000113s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2087 LIMIT 1 [ RunTime:0.000121s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2088 LIMIT 1 [ RunTime:0.000105s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2089 LIMIT 1 [ RunTime:0.000121s ]
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.000364s ]
SHOW FULL COLUMNS FROM `xin_enquiry` [ RunTime:0.000786s ]
SELECT `quotation` FROM `xin_enquiry` ORDER BY `id` DESC LIMIT 100 [ RunTime:0.000157s ]
