SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442806 LIMIT 1 [ RunTime:0.002178s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442806 [ RunTime:0.005398s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512143,744588,246815,374089,757455,758674,887036,991853,679023,186547,482986,1037558,118484,852005,207890,158457,654931,737684,171294,850534,229823,919141,494208,162063,158579,440720,614253,925424,883115,424876,493500,949116,152424,869730,627281,907381,204544,526918,506067,335322,744094,1031875,728822,393858,462167,477049,291222,350899,447960,788223,460712,869398,142972,831391,962294,50383,77411,726428,861975,543318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002864s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]