SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 120928 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 120928 [ RunTime:0.003437s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295497,956959,458587,902372,185810,986805,778033,257926,180518,267333,936980,926857,546097,34787,7544,463475,241830,499545,523723,570716,313295,654592,381748,971705,45705,359503,546211,498899,414095,118016,7297,523956,487749,807576,902078,748784,922615,70483,520469,31704,155134,133181,167555,1022999,548139,972815,142253,543717,820140,499202,616781,731603,500356,301986,513832,974337,259878,451635,13219,680329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 120928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000589s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 120928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001194s ]