SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317208 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317208 [ RunTime:0.002533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (14880,454228,991541,636097,678296,427698,232307,669649,357849,719093,654682,579361,719584,695701,49297,341696,868629,330734,112205,990661,481824,458247,761382,875201,958354,232293,132208,491808,173811,292497,120331,160061,67709,694401,188482,594269,895991,555992,149652,444099,46467,477907,568061,784076,280386,947840,945993,627997,173434,534539,353767,438202,391217,1006872,307469,583297,256531,297512,868955,452548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]