SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042873 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042873 [ RunTime:0.001585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (921962,282248,617351,956861,7171,370981,445533,772649,998376,958249,726870,734878,449790,386635,331890,416329,269767,936309,549216,208712,158000,526754,668835,132606,601900,938138,743001,717078,893191,1013595,246796,766302,303339,489149,908057,779109,759410,119194,553976,917759,270910,571977,791615,8178,233910,54557,169255,169477,478769,132250,659908,218529,100660,192493,780204,617068,474495,591624,796889,485569) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042873 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042873 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]