SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44448 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44448 [ RunTime:0.002460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570481,75022,668486,758441,498790,84813,809530,699239,97534,361740,629785,120024,754299,66615,1014230,201673,371810,1047899,706986,310125,881314,740527,409198,705258,959440,186910,213384,631509,910825,561524,189956,962737,1046318,955885,712705,501432,223250,698220,830525,414812,445209,690988,455052,391416,236314,660602,86406,1016152,1016804,296244,850210,919908,374995,285183,662801,685774,1015837,500640,579936,1033624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001571s ]