SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 572438 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 572438 [ RunTime:0.001936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (361249,1020969,240959,407418,160361,192011,91119,571417,149216,426886,709741,399451,826598,360812,39931,377273,282018,551711,430554,333019,94497,393741,949862,613088,477263,124929,674146,718036,641216,811617,552768,579274,435029,541303,688522,54755,279272,1034588,411653,30580,189996,377977,704436,145421,118327,561349,278494,932435,119974,37125,1034300,459965,805484,753193,17227,771796,757461,109509,94876,139520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 572438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 572438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]