SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003046s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 909810 LIMIT 1 [ RunTime:0.000510s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 909810 [ RunTime:0.004589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (526072,686304,693324,1026592,552245,984451,873662,531486,446902,246386,837585,448280,430121,65463,723449,46432,568797,680444,524741,837847,897697,298428,296035,227631,969091,587213,671373,1024480,112686,988498,802626,994531,795107,938345,57541,743987,758647,696924,488302,477414,239784,911564,466975,132017,378765,583883,228646,258137,921019,506844,920402,510506,813448,488704,675911,1008589,174051,213043,394621,325902) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 909810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 909810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]