SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 579457 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 579457 [ RunTime:0.002000s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (177505,611263,142032,783905,284909,354869,2017,569924,551342,90581,921123,697944,480187,696436,389033,454631,82766,453322,1026422,424743,695518,739175,687978,711271,1008726,976746,225554,614949,384097,338573,180640,371788,231754,19644,458278,674282,358763,786627,169455,172014,679048,88370,136669,286700,916987,899990,29200,858824,747199,994840,725284,998466,138247,335808,316110,501658,762461,844510,500190,961108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 579457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 579457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]