SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001872s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406261 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406261 [ RunTime:0.001617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (79823,746963,788821,402285,403051,623984,881976,665839,591309,738263,1042543,133566,356385,857421,543985,544949,813917,79461,174077,129815,669726,37884,115817,1037126,846794,720937,336423,408091,21040,80121,814543,292808,361195,376225,198057,505241,12866,127238,494648,891289,473354,711112,638097,109659,568123,89037,127267,1028309,263450,172443,948438,229211,361575,617345,281763,191446,148132,789717,718662,325949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406261 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406261 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]