SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103158 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103158 [ RunTime:0.001540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107856,524395,761881,28211,414886,481789,646603,20154,541208,954399,537550,169741,1019814,1009071,65572,242474,179604,508268,253206,968473,177373,926702,349224,67348,52523,167239,802495,999736,400935,247428,54786,234583,1046764,1011624,1001595,137326,350474,579764,77929,842382,720465,671976,469350,952450,728676,485891,664602,629128,874106,852671,443239,131429,759642,879312,838661,374048,447403,735991,157849,991100) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]