SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345309 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345309 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539343,340293,411482,670749,636554,700747,821858,688699,662400,517708,462903,103466,158206,844714,874388,1038196,800834,239464,929612,535886,972822,951972,848532,513617,578889,266467,902717,224210,331925,863147,376723,604804,314275,719156,508064,43955,594127,506723,872617,959367,825448,183415,710803,590968,90449,506779,304296,236355,850751,549767,924994,671888,445339,804958,372193,737106,304465,675656,624603,341547) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]