SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460027 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460027 [ RunTime:0.001454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (553153,1000863,178649,742674,394248,886874,410232,899054,443640,227570,423517,659140,288981,372369,386935,387731,333770,515647,776540,993790,19975,361935,188453,59019,858653,664873,879161,569404,630533,796939,769690,467441,1014013,247872,308776,880416,704693,389972,1031997,146458,636557,983855,67245,1021742,795626,477947,235501,586929,199249,786611,890432,954162,631500,64700,417441,611496,637559,493462,623119,528904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]