SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100080 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100080 [ RunTime:0.001874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (727840,184827,629006,499863,694550,150528,299828,590039,913231,9829,612066,926089,235186,28905,199199,870976,722843,698344,1032413,602965,174523,736190,793899,755634,543967,516389,625856,933649,560098,134188,93044,664334,895425,331931,634607,768384,898462,739663,702709,992728,889523,923753,791781,189474,969426,800927,279780,936117,501644,716957,632803,76103,51563,139864,1032881,306060,851892,1032301,874527,92488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001735s ]