SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 35483 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 35483 [ RunTime:0.002915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (678358,954501,1023999,416355,294810,486487,338784,494645,954783,434023,567951,680463,491336,511912,429292,759501,868407,328269,340994,124045,897916,236774,281257,169030,533830,645981,793606,884602,758766,603789,1016532,427158,965306,435017,239837,937999,605080,626621,650723,1016684,910846,360774,954973,598758,78506,782230,1037318,923345,930807,474469,581973,405993,523742,541935,585476,434991,931441,62315,304097,657967) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 35483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 35483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]