SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283767 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283767 [ RunTime:0.002386s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012764,688129,640551,629893,39929,186144,658126,963591,547699,612850,936984,727015,934286,421985,198764,55517,1040105,120747,439383,683754,884246,715099,144922,64899,819970,697914,840997,987022,27178,954218,890839,337029,784101,441057,56722,1029534,140188,263937,544181,474598,127902,382340,463897,912048,676994,838065,771118,623537,301483,566336,434200,270482,420122,572418,690136,509685,578092,526450,840254,237836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283767 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283767 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]