SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001636s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401449 LIMIT 1 [ RunTime:0.001784s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401449 [ RunTime:0.001546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185932,488746,575732,911232,563003,647232,731104,1022101,75573,620036,679610,702921,549165,263671,250250,18918,504512,609471,208156,739179,529904,540660,1031307,802892,259611,956544,591555,75437,759093,909554,225201,569569,461701,142193,335728,911661,801100,206506,536882,1020646,252552,286048,473710,355071,579565,124733,264733,731236,217790,253837,13253,757335,115168,30743,1043705,1040477,144922,717293,423987,92917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401449 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401449 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]