SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403881 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403881 [ RunTime:0.003702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (371735,529574,237308,904913,134825,703066,205048,656886,385801,760150,254392,283915,532622,509249,827125,737402,130940,671843,598489,42317,587214,705748,531965,983688,179527,744796,128404,1035414,885970,78176,943341,890695,475677,397986,740387,149102,580161,280015,476320,189424,18349,721393,897302,903010,429764,139634,551904,566187,18519,920906,669263,592135,23763,1001600,9483,832048,859444,117084,789110,612625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]