SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53778 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53778 [ RunTime:0.002690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (16172,420148,1044152,897853,567405,983875,1012036,388396,794259,864141,421965,179169,543541,710383,543156,715264,221765,878667,424475,104859,674249,21787,639396,315201,813207,438226,214828,568353,862804,678167,231197,801368,894254,935246,750480,332757,566060,570015,343972,534165,418124,901115,488477,712922,632280,559224,938344,459964,15194,62604,77414,190831,1046407,243529,676816,532672,288379,451314,879040,647233) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002691s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53778 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53778 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]