SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002088s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415946 LIMIT 1 [ RunTime:0.000718s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415946 [ RunTime:0.004764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (998484,793326,8026,739269,501655,454973,856161,851814,231716,707787,43415,936614,339333,380264,393019,972533,933088,599414,113228,600156,212179,940055,264879,305074,247267,215715,26060,957583,613148,405074,593780,901045,923898,14325,814340,602488,384754,602476,26807,525277,640582,112265,474862,7154,771130,161846,411375,412396,853428,437226,789364,339317,234625,142035,775438,8028,700463,444551,585563,765299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003669s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415946 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001902s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415946 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001024s ]