SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467631 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467631 [ RunTime:0.001653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (355791,456725,1017518,253030,1014771,575807,875432,408199,8550,737206,370059,781713,842276,987539,924834,895617,306161,206257,1007037,60790,161475,169880,31522,70523,226701,210326,573199,376933,660367,697765,184489,99946,127575,781572,265797,498502,615248,512223,377909,938265,259006,450373,742932,898517,472352,162618,530668,17779,933123,905010,1030501,958253,615380,1023105,593353,830660,258440,251825,66005,923582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]