SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511952 LIMIT 1 [ RunTime:0.000471s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511952 [ RunTime:0.001485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (956236,873843,1035312,744397,264911,925229,430614,378595,389704,113373,703440,514104,853970,878123,315625,501959,988902,970525,985215,186549,290036,161531,730939,202138,542662,579201,1048819,501350,274653,1045202,332956,971774,247093,36781,304375,601954,410798,1016225,362574,481846,887537,238902,397606,490659,117778,448706,366720,181973,324443,228930,440137,52929,773711,954617,308411,673661,319320,45683,283591,689235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511952 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511952 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]