SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002890s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420803 LIMIT 1 [ RunTime:0.002687s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420803 [ RunTime:0.002598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710661,546437,131758,706123,937726,986231,16151,996994,125027,263430,146015,837204,665935,710678,748833,728302,137486,296501,336114,863298,180050,978459,8345,715820,1037136,997754,105247,621192,525670,271123,927843,852012,917163,115721,556083,681067,549939,340920,65314,570140,855468,508523,624288,754283,306670,495367,913020,172793,668697,378705,884926,440908,682606,670280,776302,13746,41723,180674,397894,652540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.006436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001223s ]