SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 358501 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 358501 [ RunTime:0.002219s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545542,296767,862289,516126,39398,212526,349907,637400,494601,164919,674909,733262,712415,834710,92315,896375,70684,907114,338766,104390,733645,706118,593224,434177,484588,974985,343108,75693,760498,86780,253057,1006742,917916,406690,605460,777398,637281,774245,84208,549843,356555,783516,543108,477771,617064,394579,636365,449806,640265,419177,399289,132176,354478,733633,979365,182582,565601,920003,869540,996189) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 358501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000649s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 358501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]