SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341032 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341032 [ RunTime:0.001805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532508,631313,710487,89217,362312,933711,17676,675718,308584,899388,239182,486666,206168,280192,504135,1028328,785795,703299,975469,826949,602716,378716,490227,224963,588073,415199,443463,595731,526130,907929,781952,647483,133629,601266,740234,765323,358296,476552,267019,910052,156717,9736,688244,61289,1043897,150592,299000,70926,994899,80686,667299,502485,808252,464296,885260,185652,542619,859877,429000,864457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341032 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341032 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]