SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469809 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469809 [ RunTime:0.003486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037250,255986,968278,175609,300798,24549,241287,615002,943205,746201,240546,843055,825798,558551,293920,958455,129707,325917,578139,499410,398299,813726,166909,20942,363314,271986,545072,488078,449623,937120,356255,268258,541509,761447,208078,705869,10056,449356,365304,964190,347666,936008,95555,966133,252221,563554,177900,617712,596910,498178,277718,404858,3224,237963,254015,233537,547915,876499,162454,96533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000848s ]