SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002686s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040571 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040571 [ RunTime:0.002042s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (267939,868298,967299,622509,431360,111518,325215,228310,443259,34013,657332,552723,918730,241063,744254,595785,805954,414895,1021576,1034045,1019021,402523,127529,502719,357439,77761,1044120,1008733,833188,817770,151855,983632,46848,523810,766117,624993,696999,133882,218288,236793,691147,277483,550506,893464,207453,180634,182557,346392,53171,909352,657488,970616,920116,42278,949396,1017538,234935,864972,102500,808737) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]