SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80208 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80208 [ RunTime:0.001883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (7467,268887,129236,117020,659758,300905,633072,414618,497971,305530,737006,552361,813516,915275,721440,841197,924262,234944,687844,227944,173577,1024152,698265,64476,256277,1014468,218960,159970,714805,405685,753951,759634,299670,474915,231128,320442,524786,697816,828270,1000071,734731,611572,782647,990265,700632,413719,144128,1002031,510822,63925,96806,537683,853369,608413,578431,17221,1004017,106071,916930,651470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]