SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012540 LIMIT 1 [ RunTime:0.000481s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012540 [ RunTime:0.003589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (712060,602103,255468,86081,629392,757031,340576,1030413,764821,489891,943042,477769,605225,929480,275538,60565,185283,677412,770891,306554,354109,435066,769388,601798,440199,52726,713547,460685,2317,579879,966954,42124,593483,198659,325731,455130,986680,856841,388639,811225,1043381,877047,737724,587110,945692,71768,140942,21285,648397,431085,213258,920511,795640,465524,97662,612765,429254,546260,1017006,79996) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]