SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457759 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457759 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020395,1027793,234973,1044644,877342,374095,459112,972948,613028,556057,1033473,557383,205733,786659,1008329,562016,612873,536556,827906,595133,699408,1002339,774148,16432,976296,482958,1009300,708517,275640,308418,848948,405697,327962,919343,394105,237302,903622,615045,547241,839007,695059,407235,132077,510616,125374,360551,159866,1021101,229881,624200,761205,240788,337220,801194,808835,250773,171850,1030081,447239,654870) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457759 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457759 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]