SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417975 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417975 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515914,910842,831565,332296,776222,419848,301556,419923,1023311,607152,1042044,713256,144982,546681,539590,758072,5205,400114,427908,196880,823843,973394,860599,232757,927114,783551,899597,813265,267784,347030,636790,1003405,533270,371292,820080,739653,207027,861275,772948,219302,680327,549092,745138,1007374,761403,256597,165805,357374,319923,843453,839364,58573,434054,108628,855771,625940,599591,776923,516793,473691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417975 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417975 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]