SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005450 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005450 [ RunTime:0.001475s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (697909,600431,472065,285973,369587,80661,340872,720504,959950,243131,827906,2577,447886,768849,424269,158921,837351,221104,1039687,794938,89540,1037358,419522,545012,407516,23746,220620,278026,835703,410294,362288,342720,126705,925621,619427,999530,331597,327906,453366,914992,442669,51480,665840,300697,673381,436113,661138,747471,218419,402829,473793,688895,235244,184719,90455,393152,992615,537077,304466,817036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]