SHOW FULL COLUMNS FROM `xin_quotation` [ RunTime:0.001303s ]
SHOW FULL COLUMNS FROM `xin_company` [ RunTime:0.000773s ]
SHOW FULL COLUMNS FROM `xin_sort` [ RunTime:0.000659s ]
SELECT `id`,name as title FROM `xin_sort` WHERE `deep` = 1 ORDER BY `orderby` ASC [ RunTime:0.000278s ]
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.241231s ]
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.242619s ]
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.244237s ]
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.246868s ]
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.242339s ]
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.249399s ]
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.241214s ]
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.242264s ]
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.223091s ]
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.241882s ]
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.240202s ]
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.006628s ]
SHOW FULL COLUMNS FROM `xin_expert` [ RunTime:0.001265s ]
SELECT * FROM `xin_expert` WHERE `audit` = 1 ORDER BY `update_time` DESC,`id` DESC LIMIT 15 [ RunTime:0.031532s ]
SHOW FULL COLUMNS FROM `xin_file` [ RunTime:0.001284s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2125 LIMIT 1 [ RunTime:0.000276s ]
SHOW FULL COLUMNS FROM `xin_project` [ RunTime:0.000856s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '21' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001587s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2203 ORDER BY `file_id` ASC [ RunTime:0.000173s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2212 LIMIT 1 [ RunTime:0.000122s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '30' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001451s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2115 LIMIT 1 [ RunTime:0.000121s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '14' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001421s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2117 LIMIT 1 [ RunTime:0.000126s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '15' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001447s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2127 LIMIT 1 [ RunTime:0.000212s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '23' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001491s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2129 LIMIT 1 [ RunTime:0.000129s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '25' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001396s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2130 LIMIT 1 [ RunTime:0.000134s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '26' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001388s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2118 LIMIT 1 [ RunTime:0.000109s ]
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.000113s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '28' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001405s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2131 LIMIT 1 [ RunTime:0.000112s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '27' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001409s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2128 LIMIT 1 [ RunTime:0.000112s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '24' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001401s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2126 LIMIT 1 [ RunTime:0.000111s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '22' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001405s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '44296' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001381s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '44295' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001463s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '44294' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001434s ]
SHOW FULL COLUMNS FROM `xin_adver` [ RunTime:0.000924s ]
SELECT * FROM `xin_adver` WHERE `status` = 1 AND `position_id` = 1 LIMIT 12 [ RunTime:0.000222s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2090 LIMIT 1 [ RunTime:0.000148s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2085 LIMIT 1 [ RunTime:0.000115s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2073 LIMIT 1 [ RunTime:0.000107s ]
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.000120s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2079 LIMIT 1 [ RunTime:0.000114s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2080 LIMIT 1 [ RunTime:0.000107s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2084 LIMIT 1 [ RunTime:0.000114s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2086 LIMIT 1 [ RunTime:0.000108s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2087 LIMIT 1 [ RunTime:0.000105s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2088 LIMIT 1 [ RunTime:0.000106s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2089 LIMIT 1 [ RunTime:0.000108s ]
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.000372s ]
SHOW FULL COLUMNS FROM `xin_enquiry` [ RunTime:0.000782s ]
SELECT `quotation` FROM `xin_enquiry` ORDER BY `id` DESC LIMIT 100 [ RunTime:0.000158s ]