SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422717 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422717 [ RunTime:0.003322s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124103,877319,569948,137151,580900,720508,3749,215752,657240,192349,500944,559529,1020590,186450,348164,411795,656739,838578,303662,290075,219843,2141,526867,922075,665486,896607,763694,604599,872612,351351,289899,309614,338747,177327,163648,602310,370745,131645,1040418,512293,969624,987107,594379,623188,622049,823050,621552,392780,279505,180618,389928,410473,310534,1028374,399570,460252,844704,908734,214181,915199) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422717 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000673s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422717 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]