SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414823 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414823 [ RunTime:0.002385s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (139395,935655,908885,900627,925264,1011556,580499,1048314,763087,799278,468205,1008149,26272,491186,482161,504235,888562,807117,641655,306572,103923,191516,613127,698182,234367,871109,644235,265956,478429,822897,1019593,1019134,510729,871815,73345,249167,107491,827463,113789,771565,138543,880427,879686,329108,988733,404503,769971,851232,63265,892539,35081,792335,625108,804655,486467,444650,798273,228735,791788,536913) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]