SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417787 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417787 [ RunTime:0.003863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (376775,280167,982166,450330,591656,264557,911658,1008976,88959,468189,503357,235046,251962,297948,695035,359306,593434,738987,477546,328439,313847,756361,708189,663655,110713,563091,624407,338152,111750,675952,185606,383663,12922,705294,996107,424688,858000,738752,286687,704757,934731,262133,746564,382482,203988,111648,858216,234524,581584,776644,500380,129111,211475,872212,543027,693292,996315,437272,908771,758591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417787 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417787 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]