SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596615 LIMIT 1 [ RunTime:0.001414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596615 [ RunTime:0.001995s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513150,933287,860627,502817,279341,87274,486542,789588,141,155189,560022,450590,761359,967688,756263,544973,531298,569336,11508,734944,986321,505944,95278,287253,916996,333326,357404,903497,180040,1683,141129,456288,727230,750203,837349,864961,297564,1021931,571475,608175,583279,736992,458738,74994,930548,968045,559741,18377,543509,675499,654017,359933,103437,260299,1020551,876083,156399,1007904,882690,119856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000848s ]