SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 492418 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 492418 [ RunTime:0.002731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (484234,896386,411222,780389,492904,794553,272441,134104,746727,891474,246819,786379,848195,109238,385046,940962,662497,168938,900789,959784,778677,3434,321020,423408,499570,44414,6390,385020,263286,1036766,343635,164239,134731,834093,27320,1005282,124585,530302,746938,111125,669741,42671,981499,11347,465354,270079,94002,106606,975229,965716,799965,690577,227808,711266,100404,605205,606127,467987,303281,242860) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 492418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 492418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]