SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417252 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417252 [ RunTime:0.001546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (781798,111135,757883,714781,875536,572667,350759,581608,253268,684802,943424,994536,177035,896362,975670,86544,479655,1017205,825549,596012,440660,1010628,131483,83218,334236,450580,279106,308567,982037,840343,903210,359591,63204,844890,39283,505764,473395,981496,365295,636244,985558,908128,619558,329159,799164,304900,125854,52914,725032,506752,1035471,575790,1020542,79899,209313,46896,559363,151309,571851,216452) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417252 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417252 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]