SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015423 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015423 [ RunTime:0.001608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (775009,31481,396031,589640,527724,652193,1020014,266804,728126,820826,818111,472691,567972,1013245,648446,524316,574712,190690,828136,1021873,166231,211816,103702,303063,398230,786353,863714,486274,751775,609309,28295,374543,934922,474746,587867,841031,260880,874534,318106,763524,119853,631817,624028,229938,268882,519860,156241,484284,69322,356646,166135,207268,327542,354744,433988,779461,238357,947967,457876,1031799) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]