SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 984545 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 984545 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544211,489902,380706,1026475,240687,320987,267723,771715,469952,165827,135811,385794,338358,516190,791827,5741,947665,291025,973942,427408,1026876,11620,99436,762095,643564,339410,141222,98395,170074,734822,708652,1004616,106076,785806,198448,338849,1038436,46643,343338,1018113,481495,929866,165473,352901,226987,198036,644999,499575,627153,771420,1034769,242972,449690,1046690,47117,994166,614943,864673,236009,1009049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 984545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 984545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]