SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528774 LIMIT 1 [ RunTime:0.003864s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528774 [ RunTime:0.005151s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (241046,412412,1027385,453102,1038761,311240,474682,45560,625144,1028532,206412,806523,508897,788263,65696,205180,450544,169084,455996,418439,457085,229237,918233,242654,929229,666722,643600,371220,125165,464293,3120,121236,138205,911986,714639,871155,859654,812977,304808,314601,902739,271523,266219,833513,94303,938121,343225,400543,387489,1028484,1047193,46404,1028416,357310,489383,36858,1007196,139481,129078,247007) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528774 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528774 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.009767s ]