SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481570 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481570 [ RunTime:0.003742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (970310,255814,1005407,497346,345740,976454,468837,774351,793654,8226,860801,333105,409758,991490,822516,767429,967046,16033,15359,999709,675737,757837,60748,541214,555250,876185,202281,492314,137473,203994,621438,120635,109352,336995,546639,506056,824935,692420,377057,157739,52362,343971,461453,145992,868142,865509,834244,65216,28930,717464,783889,783988,632881,426570,9410,230811,22237,581265,641583,503432) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]