SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51141 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51141 [ RunTime:0.001758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (594435,995427,163614,66712,104671,974051,669904,828052,947698,783315,161197,571737,101588,674355,1046622,137671,282443,972009,596215,952841,550524,1000892,407062,876479,891502,401772,188345,413003,147474,1032398,970019,1006489,1031414,37373,891155,737983,261843,537344,346303,1002316,527028,473132,463485,873155,583545,156249,493570,515577,459953,675220,471340,15937,1321,559103,333018,92729,749474,344130,211720,471469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000622s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]