SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044380 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044380 [ RunTime:0.002882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400475,465584,29432,428922,1007744,284903,388676,260288,364199,279822,793997,224340,569816,866616,882121,12745,1004829,918127,556279,492959,4102,406039,473415,832772,274073,152332,355345,637511,946121,156467,955582,799789,401144,887150,49772,843189,812214,504649,771129,250096,676636,876094,217165,558538,511332,556359,298764,1025654,262512,932,662072,11529,1028019,320992,919966,487703,867283,125440,81706,550488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]