SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 323480 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 323480 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120054,1047135,632140,254309,458122,152922,745950,235585,328405,566994,785100,854327,523716,825383,453392,981483,579129,1016745,172173,771477,422123,164249,438750,156365,144626,152525,968131,1039089,689141,394830,484258,193783,35582,359300,893634,489668,843980,602355,931639,54150,831251,418619,801679,48600,231467,514589,639236,283858,903330,710666,407438,707259,714880,624385,302481,956437,119827,274658,644159,254403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 323480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 323480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]