SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529104 LIMIT 1 [ RunTime:0.000614s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529104 [ RunTime:0.002203s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (471971,188727,33068,501534,526630,562715,643710,303342,199638,364985,1003002,918822,208791,543065,993575,754336,117161,400400,914008,418185,588980,447659,492603,834895,752793,605643,824857,1015890,787458,263722,564105,860217,816689,242080,682088,447292,1033875,75409,1040387,519671,102177,828586,117707,799743,578811,414351,929598,190425,21113,84778,973789,752059,54262,535200,104259,485398,194644,229005,328966,982567) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]