SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013418 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013418 [ RunTime:0.002257s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (683163,295050,63286,1024442,321597,878916,800377,169621,82136,986790,917954,150871,1041234,36175,1017584,604969,775487,533663,105034,1032703,552980,225767,637897,379890,1010249,843651,187679,288588,228195,262116,960881,534475,300066,559282,733363,669651,271138,293958,56559,9421,756932,466567,434452,798754,545023,116771,781558,163402,573626,494973,1042985,709321,429312,1014989,912493,456982,134252,392618,932745,177583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000938s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]