SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412305 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412305 [ RunTime:0.001878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (671097,839805,446117,340348,527550,59247,1028104,330041,965048,1047710,943998,305742,237358,98067,626610,235073,204634,345975,144249,558131,40193,72969,150655,918739,861318,91565,1029713,600493,881885,578419,144611,299750,141439,338247,695842,214079,238570,570574,733680,700801,766202,2986,302826,664041,605217,221124,95614,512544,465882,201337,684898,595396,631475,69914,890717,1009262,933970,384981,459902,663525) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412305 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412305 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000725s ]