SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009811 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009811 [ RunTime:0.002138s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (7807,923029,1024487,279896,531385,387238,553315,28604,138855,518458,977253,188507,356662,124547,854908,352736,3173,371592,1045888,780288,332327,546074,470536,895346,935020,544785,102574,1035079,80605,275214,495227,929397,212580,777654,388786,519311,58270,118200,989588,407999,684158,512888,900254,593390,291120,244646,683962,942563,60938,604880,954837,118124,192129,996009,89997,179553,1046926,314611,464934,539101) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]