SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 262795 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 262795 [ RunTime:0.002102s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523335,475612,279177,200909,804321,181132,476727,255778,393831,522472,1038936,644460,731819,447309,558868,19260,248609,70639,518597,72041,339615,585031,580,779171,615307,677484,233497,1046793,290647,240250,762407,639569,551783,277853,180144,569345,660188,139536,184892,239100,159263,244089,422793,186876,120585,820834,934113,460880,564383,50989,638532,921921,809760,621154,617019,161926,649809,15307,878574,655036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 262795 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 262795 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]