SHOW FULL COLUMNS FROM `xin_quotation` [ RunTime:0.001205s ]
SHOW FULL COLUMNS FROM `xin_company` [ RunTime:0.000841s ]
SHOW FULL COLUMNS FROM `xin_sort` [ RunTime:0.000674s ]
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.242641s ]
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.236923s ]
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.231337s ]
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.238410s ]
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.232532s ]
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.239058s ]
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.231641s ]
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.236047s ]
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.215688s ]
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.321838s ]
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.258232s ]
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.006353s ]
SHOW FULL COLUMNS FROM `xin_expert` [ RunTime:0.001206s ]
SELECT * FROM `xin_expert` WHERE `audit` = 1 ORDER BY `update_time` DESC,`id` DESC LIMIT 15 [ RunTime:0.031141s ]
SHOW FULL COLUMNS FROM `xin_file` [ RunTime:0.001104s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2125 LIMIT 1 [ RunTime:0.000356s ]
SHOW FULL COLUMNS FROM `xin_project` [ RunTime:0.000812s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '21' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001530s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2203 ORDER BY `file_id` ASC [ RunTime:0.000197s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2212 LIMIT 1 [ RunTime:0.000119s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '30' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001446s ]
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.001417s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2117 LIMIT 1 [ RunTime:0.000128s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '15' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001389s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2127 LIMIT 1 [ RunTime:0.000111s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '23' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001383s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2129 LIMIT 1 [ RunTime:0.000107s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '25' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001394s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2130 LIMIT 1 [ RunTime:0.000108s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '26' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001381s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2118 LIMIT 1 [ RunTime:0.000110s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '16' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001418s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2132 LIMIT 1 [ RunTime:0.000147s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '28' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001394s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2131 LIMIT 1 [ RunTime:0.000113s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '27' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001381s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2128 LIMIT 1 [ RunTime:0.000108s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '24' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001396s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2126 LIMIT 1 [ RunTime:0.000112s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '22' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001474s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '44296' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001390s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '44295' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001391s ]
SELECT `id`,`title` FROM `xin_project` WHERE `expert_id` = '44294' ORDER BY `start_date` DESC LIMIT 1 [ RunTime:0.001379s ]
SHOW FULL COLUMNS FROM `xin_adver` [ RunTime:0.000935s ]
SELECT * FROM `xin_adver` WHERE `status` = 1 AND `position_id` = 1 LIMIT 12 [ RunTime:0.000197s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2090 LIMIT 1 [ RunTime:0.000146s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2085 LIMIT 1 [ RunTime:0.000117s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2073 LIMIT 1 [ RunTime:0.000141s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2076 LIMIT 1 [ RunTime:0.000105s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2077 LIMIT 1 [ RunTime:0.000108s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2079 LIMIT 1 [ RunTime:0.000104s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2080 LIMIT 1 [ RunTime:0.000101s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2084 LIMIT 1 [ RunTime:0.000100s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2086 LIMIT 1 [ RunTime:0.000102s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2087 LIMIT 1 [ RunTime:0.000110s ]
SELECT * FROM `xin_file` WHERE `file_id` = 2088 LIMIT 1 [ RunTime:0.000208s ]
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.000367s ]
SHOW FULL COLUMNS FROM `xin_enquiry` [ RunTime:0.000792s ]
SELECT `quotation` FROM `xin_enquiry` ORDER BY `id` DESC LIMIT 100 [ RunTime:0.000174s ]