SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001783s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314405 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314405 [ RunTime:0.002274s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024243,688447,532120,2780,1048122,255876,911016,345360,403039,396928,1028269,912322,489264,65592,294043,242470,600703,62599,416406,112604,94768,114417,407845,85093,198998,399709,227189,951989,609601,529060,660246,115085,637138,260994,956854,951017,816800,445152,287718,655872,538013,1226,33709,618782,412144,276037,31427,239694,953023,901076,975396,239231,179328,108248,517988,675234,821710,982562,240128,493393) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001662s ]