SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544045 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544045 [ RunTime:0.003416s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003852,161741,105853,754154,715834,605306,246931,3066,601991,716972,2835,744347,85109,231450,908148,82948,226368,169750,860735,458906,418441,429918,269192,51162,95476,594970,253779,889879,830655,267526,371510,336606,659144,574111,153754,270937,422180,637512,833392,951788,514526,639985,245020,277115,586547,723609,882387,599417,940102,567953,1009482,705395,235871,612749,705876,2389,558996,147214,1001202,60443) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001737s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]