SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 645021 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 645021 [ RunTime:0.002473s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563559,369934,618042,883530,464392,789877,128429,901260,780424,168449,984825,809681,499669,500035,1023768,824067,210110,547729,737565,545008,116881,367232,292152,1010201,558416,230636,782829,161220,70904,810495,681006,964539,343062,222171,405278,1040443,256026,1006390,994093,1009852,672014,846717,1010759,284124,528421,468068,735543,430186,382847,362036,820400,1034880,415135,73800,618835,746186,934027,605622,896198,80746) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 645021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 645021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000934s ]