SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004943s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40808 LIMIT 1 [ RunTime:0.007107s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40808 [ RunTime:0.009317s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (129594,177084,216540,37690,537236,737120,925183,297478,156689,902253,198344,995773,163690,531919,959732,300354,23266,316934,640779,833470,891381,402929,320663,791482,1003942,912190,263313,180518,473237,233006,73765,92544,13678,931022,873675,693675,808876,262958,519402,550695,996426,444818,1026088,882372,1000868,752228,217120,957336,10272,385726,978650,740753,599495,701117,837688,37009,751911,92022,555832,465018) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]