SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548038 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548038 [ RunTime:0.002736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522805,802193,973025,86186,1038787,749837,915494,734820,968074,127072,930330,214589,619973,903293,518651,48282,1010280,161963,327852,939762,191465,812218,657539,55167,490672,346921,305070,644758,310875,623649,987102,250110,585553,916188,497489,612852,197329,378535,563813,605326,836211,609586,622720,414014,198392,613066,115477,17150,248759,338086,603442,818439,695791,795594,1029089,1012941,245743,706942,272758,303478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]